Create Time of Day Crime Data

Step 1: Create Time of Day Crime Data (Copy and Paste chart we just created)

                 a. Line up the charts so they are all uniform.

                 b. Shared axis = Time of Day and Time by Hour, Tooltips = same but add Time by Hour





                 c. Sort by Time by Hour on bottom right chart

                 d. I am going to size the charts to be a bit bigger by hand. I am also going to change the Violent Crime Rate YOY and Major Crime Rate YOY to smaller legend names.



           

Check out how to create drill down in Power BI.


Drill Down Insight Link